--Look for Applicaiton ID for WinBEAT

use oit_master
select * from InfApp_Application

--app_id = 5

-- Look for the winbeat database 
-- goto the monitoring folder and open an XML dumped by WInBEAT
--Westcourts is L:7657d882-bbb9-0744-8760-60b15f3d3215
select * from InfSrcDb_SourceDb where SrcDb_name = 'L:7657d882-bbb9-0744-8760-60b15f3d3215'
--srcdb_id = 1

-- look for monitoring folder where app_id = 5
select * from InfWinFldr_WindowsFolder where App_id = 5
-- pick the winfldr_id for the folder that you want to make changes to
-- in this case windfld_id = 1


--pickup the com_id of the database in which this Push is configured
select * from Com_Company
--com_id = 2

-- pickup the push id by specifying the Winfldr_id and Com_id
select * from InfPsh_Push where WinFldr_id = 1 and Com_id = 2

-- psh_id = 1 if more than one records are returned then make a note of all the psh_id

-- check if you got the correct psh_id
select a.*, b.*
from InfPshSrcDb_PushSourceDb a, InfSrcDb_SourceDb b
where a.Psh_id = 1
and a.WinFldr_id = 1
and a.SrcDb_id = b.SrcDb_id
and b.SrcDb_id = 1
-- it has returned L:7657d882-bbb9-0744-8760-60b15f3d3215 so it means we have got the right psh_id

-- Now let us add the alias
-- An alias will be considered only if the rules is written to consider the alias. If in the rule
-- it is not specified to consider aliases then it will not consider the data added to the alias table.
-- If the interface is setup with WinBEAT then you can set alias only on Account Manager (based on the current schema that is provided).
-- In a given Push you can select any one of this only and you cannot have more than one alias per push

select * from InfOITFldrAlias_OITFolderAlias where Psh_id = 1 order by Alias
-- at Westcourt Account Manager is used as Alias. The new Account Manager is WEST and we now have to pickup the AtoZ folder
-- where its clients are to appear
-- before that let us verify if we have got the correct code for the Account Manager
-- Fin Foster all use FFAPB winbeat database
-- Westcourts all use Westcourt
SELECT * FROM Westcourt..AccountManager ORDER by Code

-- Let us verify if this account manager is is already configured in OIT
use oit_master SELECT * FROM InfOITFldrAlias_OITFolderAlias WHERE Psh_id = 1 and Com_id = 2 and Alias = 'WEST'

-- so instead of inserting we need to update to change the folder id which is stored in the column "OIT_FOLDER"
UPDATE InfOITFldrAlias_OITFolderAlias set OIT_Folder = 1194741 WHERE OITFldrAlias_id = 121


--if an entry for West was not exisitng then the above SELECT query would not have returned any rows. In that case we would add an 
-- entry as shown below)
insert into InfOITFldrAlias_OITFolderAlias(Psh_id, Com_id, OIT_Folder, Alias)
values (1, 2, 1194741, 'WEST')

-- the alias is now added. To poulate them in in OIT, from Winbeat: File > Administration > Update Document Folder > 'All for Acct Man' drop-down


RANDOM SCRIPTS THAT YOU MIGHT NEED:
select * from SystemOption where OptionName = 'ledgerid' and OptionValue = 'L:79baf766-93ab-224b-bca5-a58ddee964e9'

select * from AccountManager where code like 'BREE%'

select * from oit_master..InfOITFldrAlias_OITFolderAlias where alias like 'bree%'

select * from client where clientid = 2928 --code = 'VBMGROU'
select * from AccountManager where AccountManagerID = 43

select * from oit_master..InfOITFldrAlias_OITFolderAlias where alias like 'kevin%'